﻿CREATE TABLE [dbo].[DatabaseFile] (
    [DatabaseFileID]  INT             IDENTITY (1, 1) NOT NULL,
    [DatabaseID]      INT             NOT NULL,
    [File]            VARCHAR (4000)  NOT NULL,
    [FileGroup]       VARCHAR (4000)  NULL,
    [Drive]           VARCHAR (4000)  NULL,
    [SizeInMb]        DECIMAL (12, 1) NULL,
    [FreeSpaceInMb]   DECIMAL (12, 1) NULL,
    [AutoGrowth]      BIT             NULL,
    [MaxSize]         INT             NULL,
    [GrowthPercent]   INT             NULL,
    [GrowthMegaBytes] INT             NULL,
    [IOStallReadMs]   BIGINT          NULL,
    [NumOfReads]      BIGINT          NULL,
    [IOStallWriteMs]  BIGINT          NULL,
    [NumOfWrites]     BIGINT          NULL,
    [nrVLF]           INT             NULL,
    CONSTRAINT [PK_DatabaseFile] PRIMARY KEY CLUSTERED ([DatabaseFileID] ASC),
    CONSTRAINT [FK_DatabaseFile_Database] FOREIGN KEY ([DatabaseID]) REFERENCES [dbo].[Database] ([DatabaseID])
);







